How to: Specify data source for the query.
Solution:
Click 'New' in the Database window and select 'Design View'. Select the data source from the 'Show Table' dialog box.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Click 'New'. (The New Query dialog box appears.)
4) Select 'Design View' from the list box.
5) Click 'OK'. (The new query opens in Design view, with the Show Table dialog box open.)
6) Do one of the following to specify the data source:
a) Click the 'Tables' tab to list tables only.
b) Click the 'Queries' tab to list queries only.
c) Click the 'Both' tab to list both tables and queries.
7) Select the tables and/or queries to use for the new query.
NOTE: To select more than one adjacent table/query, press and hold down SHIFT while selecting the tables/queries. To select more than one non-adjacent table/query, press and hold down CTRL while selecting the tables/queries.
8) Click 'Add'. (The selected tables and queries appear in the Query Design window behind the Show Table dialog box.)
9) Click 'Close' to close the 'Show Table' dialog box.
